home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
PC-SIG: World of Utilities
/
PC-SIG's World of Utilities (PC-SIG) (1994).iso
/
SWMAG
/
DISK3088.ZIP
/
HOUSE.EXE
/
MANUAL.FRM
< prev
next >
Wrap
Text File
|
1993-02-05
|
59KB
|
2,229 lines
┌───────────────────────────┐
│ ┌───────────────────────┐ │
│ │ AROUND THE HOUSE v1.4 │ │
│ └───────────────────────┘ │
└───────────────────────────┘
For Support,.....
Bill Sturgell
BlueCollar Software
1323 South Route 68
Urbana, OH 43078
Call this number,.....
(513) 653-8388
Between 4:00PM and 8:00PM EST,....please.
_______
____|__ | (R)
--| | |-------------------
| ____|__ | Association of
| | |_| Shareware
|__| o | Professionals
-----| | |---------------------
|___|___| MEMBER
┌─────────────────────┐
│ OMBUDSMAN STATEMENT │
└─────────────────────┘
The ASP Board has set up an office of Ombudsman and appointed an
ASP member as Ombudsman. The Ombudsman's sole role is to mediate
disputes between ASP members and their customers. The Ombudsman
reports to the Board situations where he/she feels Board action
or knowledge is appropriate.
"This program is produced by Bill Sturgell of the Association of
Shareware Professionals (ASP). ASP wants to make sure that the
shareware principle works for you. If you are unable to resolve
a shareware-related problem with an ASP member by contacting the
member directly, ASP may be able to help. The ASP Ombudsman can
help you resolve a dispute or problem with an ASP member, but
does not provide technical support for members' products. Please
write to the ASP Ombudsman at 545 Grover Road, Muskegon, MI
49442 or send a CompuServe message via CompuServe Mail to ASP
Ombudsman 70007,3536."
┌────────────────────────┐
│ Around The House v1.1 └──────────┐
└───────────────┐ Table of Contents │
└───────────────────┘
Chapter 1
┌────────────┐
│ Main Menu │
└────────────┘
Brief Overview.....................................1-1
Chapter 2
┌───────────────┐
│ All My Files │
└───────────────┘
Who I Know.........................................2-1
What I Have........................................2-4
My Appointments....................................2-6
All My Notes.......................................2-9
Letters & Stuff...................................2-10
File Filter.......................................2-14
Chapter 3
┌──────────────┐
│ What I Make │
└──────────────┘
What I Make........................................3-1
Money Going Out....................................3-2
What's Left?.......................................3-3
My Vehicles........................................3-4
Chapter 4
┌────────────────┐
│ Print Reports │
└────────────────┘
From Who I Know....................................4-1
From What I Have...................................4-2
Printer Set-up.....................................4-3
User-Defined Reports...............................4-7
Chapter 5
┌────────────┐
│ Utilities │
└────────────┘
Sort Files.........................................5-1
Color Selection....................................5-1
Appendix A
Calculator.........................................A-1
┌────────────────┐
│ Chapter 1 │
└────────────┐ └────────────────────────┐
│ Main Menu,......... │
└────────────────────────────┘
"Around the House" will enable you to keep track of many of
the things I like to keep track of around my house. There may be
things you would like to see this program able to do that aren't
provided here. If so, drop me a line. I'll try to include them in any
updates to this program.
Here is a brief rundown of the ways and means:
The first thing I always want to know is how to exit the program.
Press <Esc> until you see a pop-up box asking if you want to exit. Select
"Yes" or "No" by using the up or down arrow keys and press <Enter>.
To select a Menu Option, use the arrow keys to move to that
selection and press <Enter>.
F1 = Help
Go to the "Menu Option" or to any place in the program where data entry
is expected and press F1 for Help.
F9 = Calculator
See Appendix A
F10 = Change index
In any browse screen you may choose a different way to index that
particular file by pressing F10. Use the arrow keys to select the desired
index and press <Enter>. The browse screen will sort the files the way you
tell it to. Indexing is not an option in the "Who I Know" database.
ENTER Used to select highlighted record and edit it.
INS Used to add a new record.
DEL Used to Delete an existing record.
1-1
┌──────────────┐
│ Chapter 2 └──────────────────────┐
└───────────┐ Who I Know,... │
└─────────────────────────┘
Selecting this menu option brings up a browse window into "Who I
Know" list. If the file is empty, you will automatically be put into
a screen for adding your first record. From the browse window
thereafter, your choices are as follows:
▀ Ins: Press the insert key to add a record.
▀ Del: Press the delete key to delete the currently highlighted
record.
▀ Enter: Press the enter key to edit the currently highlighted
record. The Who I Know edit screen will come up, and you will be able
to change the name, address, city, and all the rest of the
information.
▀ Esc: Press escape to return to the main menu.
You may navigate through the list using the cursor navigation keys,
page up, and page down. Pressing Home moves you to the top of the
file, pressing End moves you to the end of the file. Pressing the
left and right arrows shifts the fields being displayed left and
right.
You may also navigate through the file by entering a key expression.
There is one key for this file, it is Full Name. You can search the
database in the following ways;
Type in the first few letters of the last name,
Type in all of the last name,
Type in all of the last name, a space, and all or some of
the first name.
Fields,...
1. Last Name
Type in the Last Name and press the Enter key.
2. First Name
Enter the First Name. This space may be left blank if this is a
business or you just don't know the person's first name.
3. Middle Initial
Enter a Middle Initial or leave it blank and press Enter.
4. Street
Enter the Street Address.
5. City
Enter the name of the City.
2-1
6. State
Either type in the two letters of the State, or press the down
arrow until the state you need is highlighted, and press Enter.
7. Zip Code
Enter the Zip Code.
8. Phone Number
Enter the home phone number.
9. Work Phone
Enter the phone number for where this person works (or any other
phone number where this person might be reached.
10. Extension
If there is an extension to the business phone or work phone,
type it in. You don't have to enter anything if you don't want to.
In fact there are only a few fields that must contain data. And
when you don't type something there, I'll let you know.
11. Why Here
Pick a reason for their presence in the database, and press <Enter>.
You can just type in the first letter and press <Enter>.
Christmas Label Name,....
--------------------------
This will be the way you set up your label for printing.
1. Card Name
Type in the name as you want it to appear on the label.
Examples;
Mr. & Mrs. Robert Jones
The Jones Family
Bob Jones
Or whatever you want
If you don't want to send a card, leave this field blank and
press Enter.
2. Card Addendum
This is where you type in an addendum to the name.
Examples;
& Family
& The Guy in the Rented Room
& Their Rotten Kids
Leave it blank for no card, and press Enter.
2-3
Birthdays,....
--------------
1. Birthday date
If you want a print-out to keep track of the birthdays of friends
and relatives (or your doctor, favorite rock star, or anyone else you
have enteresd into your files) enter it here.
Type in the Date and press <Enter>.
2-3
┌───────────────┐
│ └────────────────────────────┐
└───────────┐ What I Have,......... │
└────────────────────────────────┘
This option will list all of the items you have around the house.
It will keep track of the serial numbers and model numbers, if
applicable. It will also print out your entire file from the
report menu, and give you a total of "how much" you've invested in
all the stuff in your house. That will suprise the daylights out of
you.
Keep this up to date and it will be very useful if you have a
loss due to theft or fire. It would be advisable to keep a back-up
disk of ALL your files at another location, your mother's, brother's,
sister's or somewhere other than your own home.
This works just like the other file entries.
Press Insert to add a record.
Highlight an existing record and press Enter to Edit that record.
Highlight the record and press Delete, to get rid of it forever.
Use the F10 key to change the indexing.
1. Item Description
Type in a brief description.
Example: Stereo, Receiver, Sofa, My bed, Knives, forks, spoons,
etc.
2. Brand Name
Type in the brand name, if you want. If you don't want to, don't
do it.
3. Date Purchased
Type in the date you bought this item. You must put something
here. This will be one of the items you will index on, so,.. if you
can't remember when you got it, make something up. But, it must be a
valid date, even if it's 01/01/01. In fact, 01/01/01 would be a useful
entry for the type of items that don't have a specific purchase date, such
as a record collection.
Don't worry about the "/", I'll do that.
4. Model Number
Type in the model number, or leave this blank.
5. Serial Number
Type in the serial number, or leave it blank.
2-4
6. Value
Just remember, whatever you enter here might someday (but, I hope
not) be given to your insurance company. So enter what you paid for
the item or the estimated value. Or any other figure you want. This
is the figure your printed report will be totalled on.
7. Classification
Select the classification that most closely fits the item, and press
Enter.
8. Location
Pick the location that best suits your location and press the
Enter key.
2-5
┌──────────────────┐
│ └────────────────────────┐
└───────────────┐ My Appointments,... │
└───────────────────────────┘
DESCRIPTION
────────────
This is a multi-user calendar with an appointment tracker.
You can point and shoot at any date and add, edit, and delete
appointments for that date. You may also print and delete
appointments for any range of dates. More advanced featured allow you
to add periodically recurring appointments, and to view days and
weeks at a glance to determine when you have free time to schedule an
appointment.
When you first enter the calendar, the current month will be
displayed along with the first two weeks of the next month. The current day
will blink. If there are any appointments for the current day, the first
seven will be displayed in a window at the bottom of the screen. Any other
days that have appointments will be displayed in reverse video on the
calendar.
ACTIVE KEYS
───────────
Left Arrow Go backward one day
Right Arrow Go forward one day
Up Arrow Go backward one week
Down Arrow Go forward one week
PgUp Go back one month
PgDown Go forward one month
Home Jump to first day of month
End Jump to last day of month
Enter Add/Edit/View appointments
P Print appointments
D Delete appointments
T Daily time block
W Weekly time blocks
C Jump to current date (system)
S Search for text in either description or notes of
an appointment
Esc Exit calendar
ADDING/EDITING/VIEWING APPOINTMENTS
───────────────────────────────────
Use the navigation keys to move to the desired date, the press
<Enter>.
2-6
A browse window will appear near the bottom of the screen showing
the time and description for all appointments. If there are no appointments
for that date, you will automatically be placed in the Add mode.
The following options are available at this point:
A Add new appointments
E Edit highlighted appointment
D Delete highlighted appointment
M Move highlighted appointment
R Recurring appointment
N edit Notes for highlighted appointment
Esc Exit calendar
To add a new appointment press 'A'. Enter the user ID (This
is who the appointment is for, not who it is with), along with the
starting and ending time and a brief description of the appointment.
┌──────┐
│ NOTE │
└──────┘
The TIME is a twenty-four hour clock. 3:00 PM would be 15:00, 9:00
AM would be 09:00 (You have to add the preceding '0' before 9:00.
The ending time cannot be earlier than the starting time. In
addition, if you try to enter an appointment that creates a time
conflict with an already existing appointment, you will get an error
message to that effect. Press Control-W to save the new appointment
or <ESC> to exit without saving.
To edit a highlighted appointment, press 'E'. Make your
changes, but the same rules apply from the Add mode. Press Ctrl-W to
save the new appointment or <ESC> to exit without saving.
To delete a highlighted appointment, press 'D'. You will be
asked to confirm your request, respond by pressing 'Yes' or 'No'.
You may move appointments from one day to another by pressing
'M'. A window will appear and ask you for the new date for this
appointment.
To add a recurring date, press 'R'. Follow the same steps as
when adding a single appointment. After you press CTRL-W, you will be
given the following options:
i Every day of the week (Mon, Tues, etc.)
ii Every other day of week
iii Every...day of the month (1st, etc.)
iv Every day
v Every...day-of-week (e.g. 3rd Monday, etc.)
vi Every weekday
Highlight the desired option and press <Enter>.
2-7
To add or edit notes for the highlighted appointment, press
'N'. A window will open below the appointment window, into which you
may type away to your heart's content. Press CTRL-W to save your
edits, or Esc to exit without saving. Appointments that have notes
attached to them will have a checkmark displayed to the right of the
description.
To exit back to the calendar, press <Esc>.
PRINTING APPOINTMENTS
─────────────────────
To print an appointment, press 'P'. You then have the option of
printing for the current week, or for a range of dates. If you print for a
week, you will be asked for a specific user ID (or "ALL" if you print for
all users). If you print for a range of dates, you will be
prompted to enter the starting and ending dates. If there are no
appointments in that range, you will be informed. Otherwise, you will
be asked if you want to include the Notes.
DELETING APPOINTMENTS
─────────────────────
To delete all appointments for a range of dates, press 'D'. You
will be asked to enter the starting and ending dates. The number of
affected appointments will be displayed, and you will be asked to confirm
your request. Press 'Yes', if you want to delete them, or 'No', if you
chicken out.
TIME BLOCKS--DAILY
──────────────────
As previously mentioned, when you are in the calendar and
appointments exist for the current date, they will be displayed in a window
near the bottom of the screen. However, let's say your in a hurry and need
to know what times are available during the day. Press 'T'. A graph showing
available and used time blocks will be displayed. The graph starts at
06:00 and ends at 22:00. Each block represents a fifteen minute
interval. There will be one row for each person who has an
appointment on this date.
TIME BLOCKS--WEEKLY
───────────────────
Weekly time blocks are similar to daily time blocks, but not as
detailed. When you press 'W', you will be presented with a daily breakdown
of appointments for the current week. In this display, each daily graph
begins at 06:00 and ends at 17:00, and each block represents an interval of
one hour.
2-8
┌───────────────┐
│ └──────────────────┐
└───────────┐ All My Notes │
└──────────────────────┘
This can be used for almost anything your heart desires. You can
use it as an electronic diary, a place to keep all your recipes,
somewhere to talk about the people you don't like, or you can use
your imagination.
Page-up and Page-down will navigate you between the screens.
Home and End will take you to the top and the bottom of the text.
The Insert key will allow you to select the insert or type-over mode.
The Backspace will erase the last letter.
The Delete key will erase the letters in front.
When you are finished, press Escape, Accept your entry. And
you're done.
1. Thoughts Date
Enter the date of this session.
2. Main subject
This will be used so that you will be able to search through
these files to find a certain topic. Type in anything that might help
you identify the most significant subject matter.
If it was your birthday, type in birthday.
If your great uncle died and left youa lot of money, type in inheritance. Get the picture?
3. Thoughts
The screen that you type in is a memo field. Each of them will hold
about twenty pages of type-written text, so you can ramble on and on.
Just start typing.
When you're finished, hit <ESC> and Accept your entry.
4. Move the "==>" down to this option and press <Enter> to print out
all your notes.
2-9
┌─────────────────┐
│ └─────────────────┐
└────────────┐ Letters & Stuff │
└──────────────────────┘
The bad news is this is not Word Perfect 5.1. The good news
is this is not Word Perfect 5.1. Hopefully, this will be a lot
easier to master.
Theoretically, this program can write files up to 64K. But,
and this is a big BUT, you must have enough memory in your RAM to
do it. You must have enough available RAM equal to twice the size
of the file you are editing. In most cases this will never be a
problem. But you might not be able to write THE GREAT AMERICAN
NOVEL.
ACTIVE KEYS
───────────
KEY ACTION
─── ──────
F1 Help screen listing all commands
Alt-A (A)ppend a file to current file
Alt-B Place block marker (or execute block command if both
block markers have already been placed.
Alt-F Insert (F)ield (for merge mailings)
Alt-G (G)o to line number
Alt-L Page (L)ength for printing
Alt-M Change (M)argins
Alt-N Edit (N)ew file
Alt-P (P)rint file
Alt-Q (Q)uit but save edits
Alt-R Search and (R)eplace
Alt-S (S)ave file and continue
Alt-T (T)oggle word wrap on/off
Alt-W (W)rite to new file
Alt-X E(X)it immediately without saving
Alt-Y Change director(Y) /wildcard
EDIT WINDOW / STATUS LINE
─────────────────────────
When you enter this option, the edit window takes up nearly
the full screen. You will be prompted to enter the name of the
file you wish to edit.
There is a status line at the bottom of the screen, which
displays the name of the file being edited (minus the directory),
the current line and column position of the cursor, the left and
right margins, and the status of the word wrap and insert modes
(displayed when active as "<Wrap>" and "<Ins>", respectively).
When a file has been edited, an asterisk will appear at the right
side of the top row next to the "Alt-H = Help" message.
2-10
FILES - CHANGING, NEW, DEFAULT
──────────────────────────────
When you press Alt-N to edit a new file or Alt-W to write to
another file, a scrolling window will appear containing all files
that match the current directory and wildcard mask. The directory
and wildcard mask will be shown at the top of this window for
reference.
To select a file, move the highlight bar to it and press
<Enter>.
To create a new file, select the option "NEW FILE", then
enter the new file name. Pressing <Esc> will abort the file
selection process.
If you attempt to write to a file that already exists, or
append from a file that does not exist, you will get a message to
that effect.
ALT-B: BLOCK COMMANDS
─────────────────────
Blocks of text may be deleted, copied, moved, printed, or
case converted. You must first mark a block of text by pressing
Alt-B at the beginning, move the cursor to the end of the block
and press Alt-B again. If you wish to move or copy this block of
text, move the cursor to the target position, then press Alt-B
again. You will see a pop-up menu of block commands ("Move",
"Copy", "Kill", "Print", "Uppercase", Lowercase", "Erase
Markers"). Select one of them by moving the highlight bar to it,
and press <Enter>.
ALT-F: FIELD INSERTION FOR MAIL MERGING
───────────────────────────────────────
You can easily insert fields from the "Who I Know" database
into your documents to create merge mailings.
First move the cursor to the location where you wish to
insert the field. Then press Alt-F to display a window containing
all available field names. Move the highlight bar to the desired
field name and press <Enter> to insert it, or press <Esc> to exit
without inserting a field.
Notice that the field name is surrounded by curly braces
("{ "Smith" }"). When the document is printed, anything
surrounded by the curly braces will be replaced by the actual
contents of the field.
2-11
When you press Alt-F, you will see a box with the Field selections.
Below is a listing of what you'll see and what each means,...
What you see: What it means:
============= ==============
KNOW->LASTNAME Last Name
KNOW->FIRSTNAME First Name
KNOW->M_INIT Middle Initial
KNOW->FULLNAME This is a field used to index
the database. If you use
this in your mail-merge it
will print the last name first.
(Doe John)
KNOW->STREET Street Address
KNOW->CITY City
KNOW->STATE State
KNOW->ZIP Zip Code
KNOW->PHONE Home Phone
KNOW->PHONE2 Work Phone
KNOW->EXTENSION The Phone Extension
KNOW->WHYHERE Why Here?
KNOW->CARDNAM Christmas Card Name
KNOW->CARDADD Christmas Card Addendum
KNOW->BDAY Birthday
If you have inserted fields into your document for Mail
Merging and press Alt-P to print, you will be asked if you want
to print more than one document. Pressing "Y" will call the "File
Filter" program. This program is discussed later.
ALT-T: WORD WRAP
─────────────────
The Word Wrap mode is "on" when you enter this
option. To turn them off press Alt-T, turn it back on by pressing
it again.
INSERT MODE
───────────
To change from Insert to Typeover mode and back again, press <Insert>.
ALT-L: PAGE LENGTH
──────────────────
The page length is set at 60 lines when you enter this
option. You can change it at any time by pressing Alt-L.
2-12
ALT-M: MARGINS
──────────────
The start up margins for the printer are set at left column
1 and right column 80. However you can change these by pressing
Alt-M and entering the desired settings. When you change them the
on-screen display will adjust to reflect the changes. You may use
larger values than would appear on the 80 column screen. In such
instances you should toggle word wrap "off" and scroll to the
right to display text beyond the on-screen right margin. The
current values of the margins appears on the status line.
ALT-P: PRINTING
───────────────
You may print the current file at any time by pressing
Alt-P. Printing may be aborted at any time by pressing <Esc>. The
format of the printed page is determined by the current settings
of the page length and margins.
If you have inserted field in this document and wish to
print a mail merging, a filter will appear here to allow you to
select which records will be printed. (It is explained later in
this chapter. (See "FILE FILTER")
ALT-R: SEARCH AND REPLACE
─────────────────────────
You can search for all or only specific occurrences of a
character string. When you press Alt-R, you will be prompted to
first enter the search string, then the replacement string. You
will then be asked if you want to replace all occurrences of the
search string. If you select "No", you will be prompted to enter
the number of occurrences to replace. Please note that the search
begins at the top of the file and continues either to the end of
the file or until the number of occurrences you specified has
been replaced.
ALT-Y: CURRENT DIRECTORY / WILDCARD
───────────────────────────────────
This little word processor gives you the ability to change
the working directory or filemask at any time. When you first
enter it, the current directory will be set to the default DOS
directory, and the wildcard will be set to "*.*". If you would
like to change either the directory where this program looks for
files or the wildcard used (e.g., "*.txt", "*.doc"), press Alt-Y
and enter the new information. You do not have to enter slashes
("\") in front or back of the directory UNLESS you include a
wildcard.
For example, to change the current directory to "\MYSTUFF\",
you only need to enter "MYSTUFF" (no quotes). However, if you
want the program to only look for ".LET" files in the MYSTUFF
directory, you must enter "\MYSTUFF\*.LET".
2-13
┌───────────────┐
│ FILE FILTER │
└───────────────┘
This is a utility with muscle. It allows you to create and
save complex queries (filters) for your "Who I Know" database.
VIEWING AND SELECTING A QUERY
─────────────────────────────
When you enter you will see a window containing descriptions
of all available queries, along with the database aliases to
which they correspond.
ACTIVE KEYS
───────────
UpArrow Move highlight bar up one query
DownArrow Move highlight bar down one query
F7 Counts records matching current query
F8 Delete current query
F9 View criteria for current query
F10 Create a new query
Enter Run current query
Esc Exit the query module
CREATING A NEW QUERY
────────────────────
Viewing field names and descriptions
────────────────────────────────────
Pressing F10 from the query window will bring up the
criteria screen. A scrolling window containing field names of
your database will appear on the right of the screen.
The following commands are available:
Enter Select current field
UpArrow Move highlight bar up
DownArrow Move highlight bar down
Letters(A-Z) Move to the next field beginning with that
letter
2-14
Selecting an operator
─────────────────────
Pressing <Enter> will bring up the operators window, which
contains the following choices:
a) Equal to
b) Less than
c) Greater than
d) Less than or equal to
e) Greater than or equal to
f) Not equal to
g) Contains
h) Sounds like
Use the Up and DownArrow to select the desired operator, the
press <Enter> to continue.
Selecting a value
─────────────────
When you have selected an operator, another window will
appear below the operators window. This window will contain the
field name and the operator. Type in the desired value for this
field, then press <Enter>.
If you wish to see all the available values in your
database, press Alt-V to pop up a scrolling window of the values.
You may select one of these by highlighting it and then press
<Enter>, or you may press <Esc> to exit without selecting
anything.
Selecting a Boolean operator
────────────────────────────
When you have entered the value, another window will appear
below the value window. This window contains the following
choices:
a) "Discard"
b) ".AND."
c) ".OR."
d) ".AND("
e) ".OR("
f) ").AND."
g) ").OR."
h) "<<DONE>>"
Move the highlight bar to the desired selection, and press
<Enter>. You will note that option f) and g) will not be
available to you until you have embedded an open parenthesis in
your query.
2-15
Ending the query
────────────────
When you are finished building the criteria for this query,
select <<DONE>> from the Boolean operator window. You will then
be asked to enter a description for this query for future
reference. The description may contain up to fifty characters.
Press <Enter> when you are finished entering the description, and
you will be returned to the query window. If you want to exit
without saving this query press <Esc>.
If you wish to run this query immediately without saving it
for future use, simply leave the description empty and press
<Enter>.
2-16
┌──────────────┐
│ Chapter 3 └────────────────────┐
└──────────┐ Where My Money Goes │
└────────────────────────┘
This option will keep track of the you money and where it all goes.
┌───────────────┐
│ └─────────────────────┐
└───────────┐ What I Make │
└─────────────────────────┘
You will not be allowed to add or delete records in this
database. It will only contain one record. This will be editable.
Use the UpArrow and DownArrow keys to move the EditArrow. When the
EditArrow is next to the field you want to change, press <Enter>.
When your income changes, just go into this option and
change the values of the fields.
1. Weekly wages
If you are paid by the week, enter the amount here. The value
will be multiplied by 4.33 (this will be the amount of monthly
income) and it will be inserted in the monthly field, automatically.
2. Monthly wages
If you didn't enter a weekly wage, enter your monthly wage here.
If you entered a weekly wage, this field will not be "0", so just press
<Enter> here.
3. Other income
Enter all of your other income here. Total it to reflect the
monthly amount.
3-1
┌──────────────────┐
│ └─────────────────┐
└─────────────┐ Money Going Out │
└──────────────────────┘
This lists all your bills.
1. This Expense
Type in a description of the expense, or the name of the mean,
old creditor.
2. Due Date
If this is a creditor, type in the day of the month this bill is
due. If this expense is groceries or something like that, skip this field.
Just press Enter and go to the last entry on the screen.
3. Weekly Amount
If this is a weekly expense like groceries, put the amount here
and I'll figure the monthly total for you. If you enter $120.00, you might
expect to see $480.00 in the monthly total come up. BUT, there are 52 weeks
in a year and that's thirteen four month periods. So, I'll multiply the
weekly amount by 4.33 to account for that extra week in a month, every so
often.
If this is a monthly bill, skip this field and enter the amount in the
monthly field.
4. Monthly Amount
If this bill is paid monthly, type in the amount here. If this is
a weekly bill, I already have the monthly amount figured. Then, just
press the Enter key, and we'll go to the next record.
3-2
┌───────────────┐
│ └───────────────┐
└───────────┐ What's Left? │
└───────────────────┘
Nothing to do here but look at what's left each month.
Sometimes that can be scary.
3-3
┌───────────────┐
│ └───────────────┐
└───────────┐ My Vehicles │
└───────────────────┘
This option will keep track of all maintenance and repair of your vehicles.
It will list all your oil changes, tune-ups, repair on dented fenders, etc.
You will be able to view the information you've compiled on the screen or
print it out to show a skeptical buyer that you've kept up the maintenance.
1. Year
Type in the year of this car.
2. Make
Type in the make of this car. (Chevrolet, Ford, Honda, etc.)
3. Model
Type in the model of this car. (Corsica, Escort, Civic, etc.)
4. Serial Number
Enter the serial number of this vehicle. This field is a must. Even if
you don't want to put in the serial number or don't want to dig out the
papers to find out what it is, you must enter something here. This is the
field that links your maintenance and repair to this vehicle.
5. Date Purchased
Enter the date you purchased this vehicle.
6. Mileage at Purchase
Enter the mileage of this vehicle at the date of purchase.
7. Purchase Price
Enter the purchase price of this vehicle.
8. Owner
Type in the name of the person on the title.
9. Principle Driver
Enter the principle driver of this vehicle.
10. Maintenance
This option will add maintenance records for this vehicle. When you first
enter the information on your vehicle, you will not see this option. After
you "Accept" your entry, highlight the vehicle in the browse screen, and press
<Enter>. The data entry screen will re-appear. *** TIP *** Use the UP arrow,
it will take you to the last field on the screen, then move it to this entry.
Another box will appear. Make your entries here. If you already have entries
in this database, press <INS> (insert) to add new records.
3-4
10 A. Date
Enter the date this maintenance was done.
10 B. Mileage
Enter the mileage at time of maintenance.
10 C. Cost
Enter the cost of this maintenance.
10 D. Description
Enter a brief description on the maintenance performed.
11. Repair
This option will add repair records for this vehicle. When you first
enter the information on your vehicle, you will not see this option. After
you "Accept" your entry, highlight the vehicle in the browse screen, and press
<Enter>. The data entry screen will re-appear. *** TIP *** Use the UP arrow,
it will take you to the last field on the screen, then move it to this entry.
Another box will appear. Make your entries here. If you already have entries
in this database, press <INS> (insert) to add new records.
11 A. Date
Enter the date this repair was done.
11 B. Mileage
Enter the mileage at time of repair.
11 C. Cost
Enter the cost of this repair.
11 D. Description
Enter a brief description on the repair performed.
12. View Report.
This will create a report you can view on the screen of information about
the vehicle and all the maintenance and repairs it has received.
13. Print Report
This will print that report. It is not necessary to view the report first.
3-5
┌─────────────────┐
│ Chapter 4 └───────────────┐
└─────────────┐ Print Reports │
└───────────────────┘
┌──────────────────┐
│ └────────────────┐
└──────────────┐ From Who I Know │
└────────────────────┘
ALL OF THESE REPORTS CAN BE VIEWED ON SCREEN OR SENT TO PRINTER
*** Thanks to a suggestion from Cheryl McKnight - Port Lavaca, Texas ***
Phone Directory
───────────────
This option will create a list of all the names and phone
numbers in your "Who I Know" files.
Address List
────────────
Press <Enter> to create out an address list.
Christmas Card Mailing List
───────────────────────────
Oops! No need to view this one on screen, it will only print.
Put your mailing labels in the printer. Use the standard 3 1/2" by
15/16" (1 across) labels.
This option will print out all the mailing labels for your Christmas
cards. This is dependent on the on the entries you made when the
"Who I Know" screen asked you if you wanted to send a card to this
person.
Birthday Card List
──────────────────
This option allows you to create a list of everyone in the
"Who I Know" database for which you entered a date in the Birthday
field.
4-1
┌─────────────────┐
│ └───────────────────┐
└─────────────┐ From What I Have │
└───────────────────────┘
THIS CAN ALSO BE VIEWED ON SCREEN OR SENT TO PRINTER
Serial and Model Numbers
────────────────────────
Creates a list of all items that you assigned a serial or model number
to in the "What I Have" screen.
All Items/Location
──────────────────
This option creates a list and totals all items in your household. It is
dependent on the location and the value you entered in the "What I Have"
screen.
All Items/Type
──────────────
This option will create a list of all items you entered in the "What I
Have" screen and group them by type.
4-2
┌───────────────────┐
│ └────────────────┐
└───────────────┐ Printer Set-Up │
└────────────────────┘
The Printer Setup Utility will allow you to define your own
printer configurations for this application. NOTE that the configuration
here pertains to ONLY the User-Defined Reports Utility. Four standard
printer configurations have been provided for your convenience.
The Printer Setup Utility is to be used in conjunction with the
built-in Report Generator. This utility enables you to define an unlimited
number of printer configurations for each report.
When you are ready to use this utility, highlight Printer Setup,
then press <Enter>, or Press the letter <S>. Once selected, the 'List of
Printer Configurations' will appear.
This browse window will contain the four standard printer
configurations that are provided with this applications. To add a new
configuration, press <Ins> from this browse window.
The Report Generator uses three different Setup Strings to
determine how to layout the lines of text before printing begins. These
strings also determine when to skip to the next page, and what escape
sequence should be sent to the printer. The Report generator automatically
selects the setup string and the page size that best fits the report. If one
line of the report will fit in the width specified in Width 1, the Level 1
setup string will be used. If the line of the report is too wide for Level 1
Width, but is less than or equal to the Level 2 Width, the Level 2 setup
string will be used. If the report is too wide for the Level 2 Width, but is
less than or equal to the Level 3 Width, the Level 3 setup string will be
used.
If the report is still too wide, the report generator will utilize
more than one line of the page per record printed, and will print on one
line as many fields as will print without breaking, and will then wrap to
the next line.
┌─────┐
│ TIP │
└─────┘
You can force the report generator to use the same setup string,
width and line all the time by setting all three levels to the same value.
This is a good idea when you are using 80 column paper in a 130 column
printer.
4-3
Explanation of each of the fields used to define Printer configurations are
listed below.
CONFIGURATION ID
────────────────
Assigns Identification Number To Configuration
Configuration ID is a unique identifier that you assign to each
new configuration. When you want to print reports, simply add the
Configuration ID Number that corresponds to the printer that will be used
to print the report. Don't use the numbers 1 - 4 since these numbers have
already been assigned to the standard printer configurations.
PRINTER DESCRIPTION
───────────────────
Provide Brief Description Of Printer
PRINTER DESCRIPTION is where you enter a brief description of the
printer that this configuration will be set for. The easiest description is
the brand and type of printer. If there are several printers of the same
brand and type, you need an additional identifier such as an extra number
or letter appended.
NETWORK PRINTER NUMBER
──────────────────────
Printer That Reports Are Routed TO
NETWORK PRINTER NUMBER is the printer number that all reports with
this configuration should be routed to. If the program is running on a
Novell network, this number should correspond to the network-assigned
printer number, where the first network printer is number 1, the second
network printer is 2, and so on.
If the program will be running on a stand-alone PC, or if the
reports with this configuration are to be routed to a printer connected to
the first parallel port on the PC, the Network Printer Number should be set
to 0 (zero).
RESET STRING
────────────
Printer Escape Sequence
RESET STRING is the escape sequence that will be sent to the
printer when the report is finished printing. This should be a string that
will rest the printer to its default powerup condition.
4-4
┌─────┐
│ TIP │
└─────┘
You should refer to the User's Manual that came with the printer
for the proper escape sequence string.
LEVEL1/WIDTH/LENGTH
───────────────────
Define Page Parameters
LEVEL1/WIDTH/LENGTH is used to enter setup strings, line widths,
and maximum lines per page. The number of lines per page should allow room
for printing header information.
Refer to the HP Laser Jet II example below for more information on
these fields.
LEVEL2/WIDTH/LENGTH
───────────────────
Define Page Parameters
LEVEL2/WIDTH/LENGTH is used on a page when a report width does not
fit in the width defined in Level 1.
LEVEL3/WIDTH/LENGTH
───────────────────
Define Page Parameters
LEVEL3/WIDTH/LENGTH is used on a page when a report width does not
fit in the width defined in Level 2.
When you are satisfied with the new Printer Configuration, press
<A> to Accept your entries. The new configuration will be written to the
Printer Setup File. If you need to make a change, press <R> and you will be
able to make changes to the appropriate field.. Press <C> to cancel the
entire entry.
Repeat the above steps for each new Printer Configuration you want
to add.
┌──────────────────────┐
│ SAMPLE PRINTER SETUP │
└──────────────────────┘
To follow along with this example you need to select Configuration
ID 'HP', Printer Name 'HewlittPackard Laser Jet II' from the List Of
Printer Configurations. Once selected, read the following explanation of
the Level 1, Level 2, Level 3, Width and Length fields.
4-5
Notice the \027 in each of the Setup strings and Reset strings.
Any time you want to include a character in a string that cannot be entered
through the keyboard, you must enter a backslash (\) followed by the
character's ASCII value. You MUST use three positions for the ASCII value
even if it is less than 100. On a HewlittPackard Laser Printer, the Escape
key has an ASCII value of 27. \027 was entered because three positions need
to be filled. This value (\027) tells the printer that the text to follow
is not to be printed, but is to be interpreted as the configuration
information.
The Level 1 Setup String tells the report generator to set the
printer to Courier font, that 80 characters will fit on one line and that
no more than 55 lines of the page will be used.
The Level 2 Setup Sting tells the report generator to switch to
the 16.6 Pica font and that 130 characters will fit on one line.
The Level 3 Setup String tells the report to stay at 16.6
characters per inch, but to switch to Landscape (sideways) printing. Now,
170 characters will fit on one line (Width = 170) and the page length will
be reduced (Length = 40).
4-6
┌──────────────────┐
│ └──────────────────────┐
└──────────────┐ User-Defined Reports │
└──────────────────────────┘
Several reports are already defined for you in the program,
however there are probably many others you will want. This utility
provides a way to define and print out an unlimited number of other
reports.
Each report is based on a primary database you select from a
window. You select the fields you want in the report, specify upper and
lower limits of field values to select for the report, and you select a
printer configuration. If the configuration you want does not exist, you
can add a new one.
You can define as many reports as you want for each file. All
reports print in a columnar format with headings. Based on the printer
configuration you select, an effort will be made to print one record per
line by switching between print sizes and types. If a complete record does
not fit on one line, it will wrap to the next line between two fields.
┌──────────────┐
│ SAMPLE USAGE │
└──────────────┘
First, highlight "User-Defined Reports" and press <Enter>.
You will see a window with the heading "List of Files". These are all the
databases in your application.
For now, let's say you want a print-out of all the Due Dates for
bills you pay each month. Highlight "Money Going Out" and press <Enter>.
The bottom of the screen will ask you to 'Enter report title or esc. to
cancel', type in 'Due Dates' and press <Enter>.
It will then ask for the 'Printer Configuration ID for this
report', type in any three-letter ID defined in the Printer Setup Utility
(CIT will work with most Dot Matrix printers), then press <Enter>.
After doing this, your screen will be a list of reports for "Money
Going Out". It should be the only on there, so highlight it and press
<Enter>. This will bring up a "List Of Fields" screen. These are all the
fields in the "Money Going Out" database.
Highlight "This Expense" and press <Enter>. A "Field Defination"
screen will appear. "This Expense" will be the only one there, press
<Enter>. The screen will ask you for the lower and upper limit. This is a
way to filter out unwanted records. We will do the filtering with the "Due
Date" field, so we won't need to enter anything here. leave these blank,
and press <Enter> two times.
4-7
Now we're back at the "List Of Fields" screen, press <Ins> to add
a new field. Using the down arrow key, highlight "Due Date" and press
<Enter>. Now we're at the "Field Definition", select "Due Date" and press
<Enter> again. This is where we'll filter out the unwanted records. We
don't want entries such as 'Groceries' or 'Gasoline Expenses' to appear
here. All we want is the entries where we entered a due date for a monthly
payment. Therefore, in 'Lower Limit' type 01, this will filter out all
records where no entry was made in the 'Due Date' field. Since there are 31
days in the longest month of the year, type 31 in the 'Upper Limit', and
press <Enter>.
UPPER AND LOWER LIMIT
─────────────────────
If you wanted a report listing all the names in the files up to,
and including, those starting with the letter 'P'. Type 'A' in lower limit
and 'P' in upper limit. Or if you only wanted all the Smith's listed, type
'Smith' in both lower and upper limits.
Now back to the "List Of Fields", press <Ins> to add the last
field we'll need. "Weekly Amount" won't be needed, so move the highlight to
the field "Monthly Amount" and press <Enter>. At the the "Field Definition"
screen, highlight "Monthly Amount" and press <Enter> again. We won't need
to limit this field, so leave them blank and press <Enter> two times. At
'Total?' press "Y".
That's it, we're finished. Press <ESC>. The program will ask you
if you want to print the report now. Highlight 'Yes' or 'No' and press
<Enter>.
If you have reports already defined and want to print one of them.
Select the database the report was defined from and press <Enter>. Then
select the report you defined and press <Enter>. And at the "Field
Definition" screen, press <ESC>.
4-8
┌──────────────────┐
│ Chapter 5 └────────────────┐
└──────────────┐ Utilities │
└────────────────────┘
┌─────────────────┐
│ └─────────────────┐
└──────────────┐ Sort Files │
└────────────────────┘
This menu option packs and re-indexes all files in the system.
It should be used occasionally, because it reduces the size of your memo
files. Therefore clears up some disk space for you.
I urge you to use this from time to time.
┌──────────────────┐
│ └───────────────────┐
└──────────────┐ Color Selection │
└───────────────────────┘
If you are using a color or composite monitor, this utility
will let you change the color settings for the screens. You can also
specify whether you want windows to explode and implode.
Press <Enter>, a screen with various color combinations will
appear. Selecting different colors for your program is simple. First,
move the edit arrow next to the area you want to re-set the colors
for (GRAPHICS, DATA FIELDS, ENHANCED, or SCREEN TEXT), then press
<Enter>. Using the arrow keys to select a color combination, move the
edit arrow to the left of the color you want to select, then press
<Enter> again. A sample of the color combination will appear in the
field for which it has been chosen.
GRAPHICS
────────
Graphics characters include menu boxes and screen borders.
DATA FIELDS
───────────
Data fields are the regions of data input(reverses video region).
For example, if a data field has a field length of 10, 10 spaces of the color
selected here will appear on the screen. It is in these 10 spaces that you
will make your entries.
5-1
ENHANCED
────────
This changes the colors of the SELECTED menu choices and
other highlight bar options.
SCREEN TEXT
───────────
All text displayed on the screen will use this color combination.
EXPLODING WINDOWS
─────────────────
This is a YES/NO option. It is used to determine whether or not
your application will have windows that explode onto the screen or sneak
into view.
5-2
┌──────────────┐
│ Appendix A └─────────────┐
└───────────┐ CALCULATOR │
└────────────────┘
This calculator includes all the basic operations, and then some. It has a
few goodies that probably won't be needed in "Around the House", but
they might come in handy if you want to figure something out. As I
already mentioned, access this by pressing F9 at any time in the
program.
ACTIVE KEYS
───────────
+ Addition
- Subtraction
* Multiplication
/ Division
^ Exponentiation
% Percentage
C Clear current total
E Clear current entry
D Change number of decimals displayed
R Round to specific number of decimals
P Print (adding machine mode)
M Memory operations (see "Memory Functions")
= Process operation
Enter Process operation
Backspace Erase last digit entered
Esc Exit Calculator
MEMORY FUNCTIONS
────────────────
To access the Memory Functions, press 'M'.
KEY: ACTION:
R Recall number stored in memory
C Clear memory (reset to zero)
+ Add current number to memory
- Subtract current number from memory
* Multiply memory by current number
/ Divide memory by current number
PRINT--ADDING MACHINE MODE
──────────────────────────
By pressing 'P' for print, the calculator emulates an adding
machine. This will be noted by a small 'P' next to the numbers window. Each
calculation will be sent to the printer (if it is on- line). After
all, if you've invested several thousands of dollars in PC hardware
and software, why spend more for a ten-digit adding machine? Press
'P' again to toggle adding machine mode off.
A-1
OTHER STUFF
───────────
The arrow keys will move the calculator around on the screen
to get it out of the way of something you might want to look at.
Pressing ALT-F10 will bring up a screen that allows you to
change the colors of the calculator. It works pretty similar to the color
selection utility. I'm not typing out all the information about that again,
I've been sitting here too long already. Play around with it, you'll figure
it out.
A-2
